<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateItemsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('items',function(Blueprint $table){

            $table->increments('id')->comment('项目ID');
            $table->string('item_name',255)->comment('项目名称');
            $table->string('item_address',255)->comment('项目所在地');
            $table->text('item_describe')->comment('情况描述');
            $table->text('item_check')->comment('考核要求');
            $table->string('item_price')->comment('保留价');
            $table->string('bidding_deadline')->comment('竞价截止日');
            $table->string('item_deadline')->comment('项目完成');
            $table->string('idea_deadline')->comment('意见回复日');
            $table->string('item_design')->comment('约定设计费');
            $table->string('member_id')->comment('业务员');
            $table->integer('item_type')->comment('项目类型');
            $table->integer('item_status')->comment('项目状态');
            $table->string('item_plan')->comment('项目进度');
            $table->integer('item_stage')->comment('项目阶段');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
